/*
 Navicat Premium Data Transfer

 Source Server         : treeRoot
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : consumption

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 20/10/2022 15:36:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for home_bill
-- ----------------------------
DROP TABLE IF EXISTS `home_bill`;
CREATE TABLE `home_bill` (
  `id` varchar(100) NOT NULL COMMENT '账单编号',
  `statement_date` date NOT NULL COMMENT '账单日期',
  `type` varchar(100) NOT NULL COMMENT '消费类型',
  `money` int NOT NULL COMMENT '消费金额',
  `uid` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '消费人',
  `is_deleted` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否被删除，0flase 没有被删除 1true被删除',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `home_bill_id_IDX` (`id`,`statement_date`,`type`,`uid`,`money`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of home_bill
-- ----------------------------
BEGIN;
INSERT INTO `home_bill` VALUES ('1553053395475001346', '2022-10-01', '娱乐', 200, '1580956305036996610', 1, '2022-07-29 00:00:00', '2022-07-29 00:00:00');
INSERT INTO `home_bill` VALUES ('1553059005193439873', '2022-10-01', '医疗', 909, '1580956305036996610', 0, '2022-07-29 00:00:00', '2022-10-16 13:50:31');
INSERT INTO `home_bill` VALUES ('1581319717768183809', '2022-10-01', '娱乐', 1000, '1580956305036996610', 0, '2022-10-16 00:22:55', '2022-10-16 00:22:55');
INSERT INTO `home_bill` VALUES ('1581326487987245058', '2022-10-01', '出行', 1400, '1580956305036996610', 0, '2022-10-16 00:49:49', '2022-10-16 13:28:26');
INSERT INTO `home_bill` VALUES ('1582077204286717954', '2022-10-01', '美食', 200, '1580956305036996610', 0, '2022-10-18 02:32:54', '2022-10-18 02:32:54');
INSERT INTO `home_bill` VALUES ('1582077335102865409', '2022-10-01', '医疗', 200, '1580956305036996610', 0, '2022-10-18 02:33:25', '2022-10-18 02:33:25');
INSERT INTO `home_bill` VALUES ('1582077351519371266', '2022-10-01', '出行', 200, '1580956305036996610', 0, '2022-10-18 02:33:29', '2022-10-18 02:33:29');
INSERT INTO `home_bill` VALUES ('1582077367138959361', '2022-10-01', '其他', 200, '1580956305036996610', 0, '2022-10-18 02:33:33', '2022-10-18 02:33:33');
INSERT INTO `home_bill` VALUES ('2', '2022-10-10', '出行', 2, '1580956305036996610', 0, '2022-10-16 00:49:49', '2022-10-16 13:28:26');
INSERT INTO `home_bill` VALUES ('3', '2022-10-10', '娱乐', 1, '1580956305036996610', 0, '2022-10-16 00:22:55', '2022-10-16 00:22:55');
INSERT INTO `home_bill` VALUES ('4', '2022-10-10', '其他', 3, '1580956305036996610', 0, '2022-10-18 02:33:33', '2022-10-18 02:33:33');
INSERT INTO `home_bill` VALUES ('5', '2022-10-10', '美食', 4, '1580956305036996610', 0, '2022-10-18 02:32:54', '2022-10-18 02:32:54');
INSERT INTO `home_bill` VALUES ('6', '2022-10-10', '医疗', 5, '1580956305036996610', 0, '2022-10-18 02:33:25', '2022-10-18 02:33:25');
INSERT INTO `home_bill` VALUES ('7', '2022-10-10', '出行', 6, '1580956305036996610', 0, '2022-10-18 02:33:29', '2022-10-18 02:33:29');
INSERT INTO `home_bill` VALUES ('8', '2022-10-10', '娱乐', 9, '1580956305036996610', 1, '2022-07-29 00:00:00', '2022-07-29 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for home_user
-- ----------------------------
DROP TABLE IF EXISTS `home_user`;
CREATE TABLE `home_user` (
  `id` char(19) NOT NULL COMMENT 'id',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `is_deleted` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否被删除，0flase 没有被删除 1true被删除',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
  `nickname` varchar(255) DEFAULT NULL COMMENT '用户名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of home_user
-- ----------------------------
BEGIN;
INSERT INTO `home_user` VALUES ('1580956305036996610', '123456', 'e10adc3949ba59abbe56e057f20f883e', 'https://img1.baidu.com/it/u=641358881,2844098460&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1665939600&t=2a673cbd7e2042a2e3fdc31e29edd8a6', 0, '2022-10-15 00:18:51', '2022-10-19 08:52:59', '郑宇洋');
INSERT INTO `home_user` VALUES ('1581300912111321089', '2', 'c4ca4238a0b923820dcc509a6f75849b', 'https://img0.baidu.com/it/u=1984893543,712051612&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1665939600&t=0c3ddfc83e7fb7a8c402c68f718ad65e', 0, '2022-10-15 23:08:11', '2022-10-15 23:08:11', '李四');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
